Tiny File Manager | customer_config_get_data

Back Back Up Advanced Editor

<?php
//======================================================================================
//
// Function: REEFTintegrationLog - get config data for customer id
//
// Programmer: AR
// Date      : 2025-05-27
//
//
// Copyright Reeft A/S (c) - 2025
//======================================================================================

//======================================================================================
// Set start time
//======================================================================================

$starttime = microtime(true);
	
//======================================================================================
// Get input
//======================================================================================

if (isset($_REQUEST["group"])) {
		$input_group = $_REQUEST["group"];
	} else {
		$input_group = '';
	}

//======================================================================================
// General config
//======================================================================================
	include "config/config.php";

//======================================================================================
// Get input
//======================================================================================

//======================================================================================
// Get session variables
//======================================================================================
	include "include/getsession.php";
	include "include/sec2hms.php";
	include "include/REEFT_date_convert.php";

//======================================================================================
// Set language
//======================================================================================

include "include/set_language.php";

//======================================================================================
// Set defaults
//======================================================================================

$entries_found = 0;

$currentDate = date('Y-m-d');
	$currentTime = date('H:i:s');

$returnCode = '00';
	$returnMsg 	= 'Alles ist gut';

// Init
	$aryDetail = array();

header('Content-Type: application/json;charset=utf-8');

//======================================================================================
// Set database
//======================================================================================

//$db_name = 'customer/REEFT_integration.sqlite3';
	$db_name = $CUSTOMER_DATABASE_PATH;
	$DFT_SQLLITE_IP	= $db_name;

//======================================================================================
// Check if database file exists
//======================================================================================
	if (!file_exists($db_name)) {
		die(json_encode(['error' => "Database file '$db_name' does not exist."]));
	}

//======================================================================================
// Connect to some DB
//======================================================================================

include "include/db_connect.php";

//======================================================================================
// Init some fields
//======================================================================================

$pk_customer 	= 0;
		$cust_active 	= '';
		$cust_number 	= '';
		$cust_name 		= '';
		$cust_group 	= 0;

//======================================================================================
// Create SQL - active records in the group
//======================================================================================
	$entries_found = 0;

$sql =  "SELECT * FROM reeft_customer WHERE cust_group = '$input_group' and cust_active	= 1";
	
	//echo $sql;
	
	include "include/db_run_sql.php";

foreach( $data as $row )
	{
		$aryDetail[] = $row;
		
		$entries_found++;
	}

//======================================================================================
// Check if data is found
//======================================================================================
	
	if ( $entries_found == 0 ) {
		$returnCode	= '99';
		$returnMsg 	= 'No data found';
	}

//======================================================================================
// Calculate response time
//======================================================================================
	$endtime 			= microtime(true);
	$response_time 		= $endtime - $starttime;
	$response_time 		= number_format($response_time, 6, '.', '');
	$response_time_raw 	= number_format($response_time, 6, '.', '');
	$response_time 		= '(' . $response_time . ' seconds)';
	$response_time_raw 	= $response_time_raw;

//======================================================================================
// Create header
//======================================================================================
	$aryHeader = array();
	
	$aryHeader["entries_found"] 				= $entries_found;
	$aryHeader["returnCode"] 					= $returnCode;
	$aryHeader["returnMsg"] 					= $returnMsg;
	
	$aryHeader["currentDate"] 					= $currentDate;
	$aryHeader["currentTime"] 					= $currentTime;

$aryHeader["input_group"] 					= $input_group;
	
	$aryHeader["response_sec"] 					= $response_time;
	$aryHeader["response_sec_raw"] 				= $response_time_raw;

// Create array and prepare for json encoding
	$returnJson["header"] 						= $aryHeader;
	$returnJson["data"] 						= $aryDetail;

//======================================================================================
// Paint it black
//======================================================================================
    echo(json_encode($returnJson));